/*
 Navicat Premium Data Transfer

 Source Server         : SQLServer
 Source Server Type    : SQL Server
 Source Server Version : 16001000 (16.00.1000)
 Source Host           : localhost:1433
 Source Catalog        : Teach
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 16001000 (16.00.1000)
 File Encoding         : 65001

 Date: 29/09/2025 09:40:58
*/


-- ----------------------------
-- Table structure for Student
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Student]') AND type IN ('U'))
	DROP TABLE [dbo].[Student]
GO

CREATE TABLE [dbo].[Student] (
  [sno] nchar(10) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [sname] text COLLATE Chinese_PRC_CI_AS DEFAULT '无名氏' NULL,
  [birthday] date  NULL,
  [stu_grage] int  NULL,
  [check_order] bigint  IDENTITY NOT NULL
)
GO

ALTER TABLE [dbo].[Student] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of Student
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Student] ON
GO

INSERT INTO [dbo].[Student] ([sno], [sname], [birthday], [stu_grage], [check_order]) VALUES (N'10002     ', N'张四', N'2005-10-01', N'2024', N'2201125002')
GO

INSERT INTO [dbo].[Student] ([sno], [sname], [birthday], [stu_grage], [check_order]) VALUES (N'10003     ', N'王五', N'2005-10-01', N'2024', N'2201125005')
GO

INSERT INTO [dbo].[Student] ([sno], [sname], [birthday], [stu_grage], [check_order]) VALUES (N'10004     ', N'赵六', N'2005-10-01', N'2024', N'2201125006')
GO

SET IDENTITY_INSERT [dbo].[Student] OFF
GO


-- ----------------------------
-- Auto increment value for Student
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table Student
-- ----------------------------
ALTER TABLE [dbo].[Student] ADD CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED ([sno])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

